Functions And Formula in Ms- Excel


 
 
Concept Explanation
 

Functions And Formula in Ms- Excel

In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.

Formula is an expression that calculates values in a cell or in a range of cells.

               For example, =A1+A2+A3+A4 is a formula that adds up the values in cells A1 through A4.

Whereas,

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

 Which of the following functions is used to find the highest value in a range ?

Right Option : A
View Explanation
Explanation
Question : 2

In MS Excel to add numeric values in column D ,from rows D10 to D15, the formula that should be used _____________________

Right Option : C
View Explanation
Explanation
Question : 3

Which of the following functions is used to count the number of cells in a range that are not empty?

 

 

Right Option : B
View Explanation
Explanation
 
 
 


Students / Parents Reviews [10]